Inserting KPI Cards and Indicators 13
?Step 1: Inserting the Card visual (Total Crossings)
1- Double click the Card from the Visua
2- Insert the value to be displayed Total Crossings Measure
3-Go to format tab
4-General and adjust the size X-Position 0, Y-Position 106, Width 191, & Height 153
5- Turn off the Category
6- Data Labels, Text Color Default, Size 40
7- Turn on the Title and Total Crossings, Size 16, Alignment Center, Background #70BBFF, Text Color #FFFFFF
8- Turn on the Border and change the color to #E6E6E6.
Step 2: Inserting the Card visual (Crossings PM)
1- Double click the Card from the Visual
2- Insert the value to be displayed Crossings per Month
3-Go to format tab
4-General and adjust the size X-Position 0, Y-Position 258, Width 191, & Height 153
5- Turn off the Category
6- Data Labels, Text Color #6B2328, Size 40
7- Turn on the Title and Total Crossings, Size 16, Alignment Center, Background #70BBFF, Text Color #FFFFFF
8- Turn on the Border and change the color to #E6E6E6.
Step 3- Creating MoM measure and set the Percentage. Do the same for the YoY measure to have a percentage value.
1- Right Click on Key Measures table ellipsis
2- New Measure
3- Enter the syntax or the calculation and click Enter.
4- Go to Format tab and Choose the Percentage from dropdown and decide how many decimals you want to be displayed.
Step 4: Inserting the Card visual for % MoM.
1- Double click the Card from the Visual
2- Insert the value to be displayed %MoM
- 3-Go to format tab
4-General and adjust the size X-Position 0, Y-Position 410, Width 191, & Height 153
5- Turn off the Category
6- Data Labels, Text Color #23BEC9, Size 40
7- Turn on the Title and Total Crossings, Size 16, Alignment Center, Background #70BBFF, Text Color #FFFFFF
8- Turn on the Border and change the color to #E6E6E6.
Step 4-1: Inserting Indicator for MoM% KPI – if the ratio is above Zero the arrow will indicate Up and the color will be green, and if it is less than zero the arrow will indicate down, and its color will be red.
1- Double click on the Card
2- Select MoM Color measure
3- Format tab and expand General X- Position 0, Y- Position 434, Width 48, & Height 45
4- Data Labels expand function tab and input condition based on MoM% and
If value is greater than or equal to 0 Number and is less than 100E9 Number, then #06F90A.
If value is greater than or equal to -100E9 Number and is less than 0 Number, then #FA0410 click OK.
5- Background set to #E6E6E6
Step 5: Inserting the Card visual for %YoY.
1- Double click the Card from the Visual
2- Insert the value to be displayed YoY%
- 3- Go to format tab
4- General and adjust the size X-Position 0, Y-Position 564, Width 191, & Height 153
5- Turn off the Category
6- Data Labels, Text Color #12239E, Size 40
7- Turn on the Title and Total Crossings, Size 16, Alignment Center, Background #70BBFF, Text Color #FFFFFF
8- Turn on the Border and change the color to #E6E6E6.
Step 5-1: Inserting Indicator for YoY% KPI
1- Double click on the Card
2- Select MoM Color measure
3- Format tab and expand General X- Position 0, Y- Position 590, Width 48, & Height 45
4- Data Labels expand function tab and input condition based on YoY% and
If value is greater than or equal to 0 Number and is less than 100E9 Number, then #06F90A.
If value is greater than or equal to -100E9 Number and is less than 0 Number, then #FA0410 click OK
5- Background set to #E6E6E6
Creating Card Visual